MYSQL - Select Statement - Basic

Just a little note to myself..

MYSQL statment to select from one table based on occurances in two tables.

  • SELECT * FROM webcal_entry LEFT JOIN webcal_entry_user ON webcal_entry.cal_id = webcal_entry_user.cal_id WHERE webcal_entry.cal_due_date = curdate() AND webcal_entry_user.cal_status != 'd'"

This entry was written by Nozzi and posted on 12:45 pm and filed under Bookmark the permalink . Follow any comments here with the RSS feed for this post . Post a comment ( in a new window )  

0 comments

Make A Comment
Subscribe to: Post Comments (Atom)
top
© Nozzi’s TECHLOG