General information
Category:
Coding, syntax & commands
>>if you ask me - mine is much simpler than the one you listed above- you have 5 SELECTS 4 of which are sub queries and mine has two simeple ones.
>>the only diff is I didn't use shortcuts for table names
>>
>>IAC , whatever you got that works is good for you
>
>Hmmm... Maybe it just seems more complicated since I don't know how to do joins and unions... Selects I get, so that seems simpler.
instead of using a JOIN you can implement this with WHERE
you may want to learn how to use JOINs though, because you can also have OUTER JOINs then, also it is more close to ANSI SQL syntax
Arnon
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only