Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: flyadvertising
- Content: Threads
- Order by date
-
Multiple JOINS
Having a problem combining 2 JOINS. Both statements below work. I have also included the relevant fields in the 2 DBs. My question is: 1) How do I combine the 2 statements into 1 statement? 2) How do I reference the rows in my php to distinguish if the result was from the mmpreID JOIN or the...- flyadvertising
- Thread
- Replies: 3
- Forum: MySQL
-
aggregate function
The query (B) below is working, but in the first LEFT JOIN I'd like to pull the most recent result. So, I'd have to add something like the query (A) below in somehow. A SELECT poArID, poDatetime FROM posts ORDER BY poDatetime DESC B SELECT articles.arID, articles.arType, articles.arTitle...- flyadvertising
- Thread
- Replies: 1
- Forum: ANSI_SQL
-
Selecet DISTINCT plus one more
The following is working great, but I need to get one more row from the second table (ppics). However, when I try to add this in, my query stops working. Any help will be much appreciated. SELECT ppre.cID, ppre.yr, ppre.make, ppre.model, ppre.vin, ppre.display FROM ppre JOIN (SELECT DISTINCT...- flyadvertising
- Thread
- Replies: 8
- Forum: ANSI_SQL
