josephman1988 Posted September 5, 2008 Share Posted September 5, 2008 Hi guys, I'm only just getting familiar with joing tables. I have the following 2 table structures. games: g_id (Primary Key + Auto Increment) g_title g_content g_release g_image news: n_id (Pimary Key + Auto Increment) n_content n_date n_image g_id So I have the following query to match the 2 id's, but How would I grab the associated g_title. This is my attempt: SELECT games.g_title, news.n_title, news.n_image, news.n_date, news.n_content, news.g_id FROM games LEFT JOIN news ON games.g_id = news.g_id ORDER BY n_id DESC Hope you can help and explain =] Quote Link to comment Share on other sites More sharing options...
fenway Posted September 5, 2008 Share Posted September 5, 2008 Could you post your "solution"? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.