By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,280 Members | 2,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,280 IT Pros & Developers. It's quick & easy.

Easy join with equal, star-equal, equal star (like MSSQL)

P: n/a
Hi folks,

I'm new with MySQL and I'm really impressed by this database engine.
While waiting for Stored Procedures :) (ver 5: anyone can say when
will be, approximately, released?), due to the fact that I'm coming
from MSSQL world, can anyone tell me if there's a way to perform join
without the classic SQL statement (inner join on, right join on, etc)
but using the WHERE clause, with equal =(inner join), star-equal *=
(left join) and equal-star =* (right join)?

Example follows:

SELECT
A.FIELD_1, B.FIELD_2, C.FIELD_3
FROM
TABLE_1 A, TABLE_2 B, TABLE_3 C
/* Here i go with joins using equals */
WHERE
A.KEYFIELD = B.A_KEYFIELD
AND A.KEYFIELD = C.A_KEYFIELD

I found this way on MSSQL very powerful and I'd like to produce the
same clean-code here with MySQL..

TIA, tK
Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.