Select from one table and sort by another table...

Im sure it sounds dumb but my setup is as follows:

I have a table with all listing information, name, address, etc.

I have another table that contains the number clicks a certain ID has recieved, the ID is the same ID used in the table with the listing info.. For example:

Table - listingInfo
listingID - 1
listingName - Joe Smith

listingID - 2
listingName - Jane Smith

table - listingClicks
clickID - 1 (That is referring to listingID 1 (Joe Smith in this case))
applyClick - (# of clicks that listing as recieved)

So again, what i would like to do, is select and output all of the listings in listingInfo table but I would like to sort them by number of clicks.. Is this possible in my current configuration?

 

you can try


select * from listingInfo,listingClicks where listingInfo.listingID=listingClicks.clickID order by listingClicks.applyClick desc;

 

Looking at your query, that would only be selecting 1 listing, I need to output them all..

 

Alam's query WILL output them all, if the listingInfo and listingClicks tables have a 1 to 1 relationship as you described. He's doing a join... did you try the query yourself?

 

I apologize to you Alam, your query worked perfectly..

Robert, thank you for pointing out that I am a dee dee dee, I didnt bother to try his query assuming it didnt work, +rep to both of you

 

I am happy to know that my script is serving u well :d