Join?

[Anon]

Hello,

I am trying to learn join querys to speed things up.

Can anyone give me an example of how this would work:

I have 2 tables.

Table 1 has username, credits
Table 2 has username, game

I am trying to select a random user from table 1 who has 1+ credits and then select a random game under that username on table 2.

Multiple querys on this seems to slow things down.

Thanks

[[deleted]]

First, a JOIN does not neccecarily speed things up.

Second,
try something like

SELECT table2.game, table2.username
FROM table1, table2
WHERE table1.username = table2.username
AND table1.credits>=1;

then you'll get all games for al users that have more than 1+ credit.
From that you can select a random record.

---

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[pnoeric]

related question - where can I find a good, basic tutorial on those advanced SQL queries like JOINs and UNIONs? I think I need one for this project I'm doing but I'm not sure how to use them.

thanks
Eric