Re: struggling with this query from two tables? anyone..

[Ramalingam Chelliah]

Hi ,
Check if this helps you ...

I have joined 'hosts' table twice with a 'sites' table ....


mysql> SELECT X.hostname,Y.hostname,Z.expires
FROM
hosts as X,hosts as Y,sites as Z
WHERE Z.host_id_1=X.ID AND Z.host_id_2=Y.ID
AND Y.ID=1;

Last comparision is with regard to Athens' ID 1 ...
You can also compare it with hostname like Y.hostname='Athens'


Hope this helps you ....

Regards,
Ram.









We Learn the Most When we have to Invent