0

In pset7 Finance, for the "History" table, this table will sum up the transactions for EVERYBODY who registered, right ?

I understand I can later use SELECT(JOIN) but is there another way to make a unique History table for each user ?

Thanks in advance!

Improve this question

1 Answer 1

Reset to default
0

There may be, but it would be extremely complicated and you simply don't want to. It would require dynamically creating a table with every user. Imagine the nightmare with thousands or millions of users!

Getting the transactions of a specific user should be easy. If you need the transactions for a particular user for a particular stock, it's straightforward. SELECT <the fields you want> WHERE userid = <user> AND symbol = <target stock> The use of join isn't needed here.

Just be sure that the history table has all the needed fields.

If this answers your question, please click on the check mark to accept. Let's keep up on forum maintenance. ;-)

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .