General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Not sure.
>>I was just curious if that will works.
>>I never used WHERE xxx IN (SELECT ....) in my queries. I prefer to use JOINS and derived tables.
>>They are fatser (In my opinion, never made proper tests though).
>
>Yes, they are almost every time faster than subqueries.
thats good to know, I'll try to think of possible ways to do things via joins in future, subqueries just generally read more easily to me, hence that being the first way I wrote it.
Previous
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