Yesideez Posted November 9, 2008 Share Posted November 9, 2008 I've got 4 tables in my database listing my music collection: albums, artists, notes, tracks I've normalised it as much as possible without going silly and here's where I'm stuck... I can write one query listing data from albums, artists and tracks but I think I need to use JOIN with notes but I've no idea which one, left or right. The last field in tracks is "noteid" which if greater than 0, reference a note in "notes" How can I write a very simple query ONLY to access the tracks and notes tables? I'd like to then try and modify it on my own to work with the other tables. Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/132068-solved-help-required-with-i-think-a-join/ Share on other sites More sharing options...
Barand Posted November 9, 2008 Share Posted November 9, 2008 see http://www.phpfreaks.com/tutorial/data-joins-unions Quote Link to comment https://forums.phpfreaks.com/topic/132068-solved-help-required-with-i-think-a-join/#findComment-686294 Share on other sites More sharing options...
Yesideez Posted November 9, 2008 Author Share Posted November 9, 2008 Thanks Barand, I've bookmarked it ready for reading when I have time to study it - quite a few pages! It's one thing that really perplexed me and I'm determined to get my head around it somehow. Quote Link to comment https://forums.phpfreaks.com/topic/132068-solved-help-required-with-i-think-a-join/#findComment-686297 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.