Joins vs .notation?
Posted: Sat Oct 20, 2007 2:47 pm
Hey everybody,
I've been doing a project with LOT of queries and relational tables...
To this point I've pretty much been using the . query notation for this...
what are the tradeoffs between using this and using 'joins' (which I don't know how to use!)
thanks
Andrew
I've been doing a project with LOT of queries and relational tables...
To this point I've pretty much been using the . query notation for this...
Code: Select all
query = 'SELECT tbl_users.id, tbl_users.name, tbl_somethingelse.something
FROM tbl_users, tbl_somethingelse
WHERE....' (you get the idea)thanks
Andrew