Search results for query: *

yes this particular query extracted from only two tables but the database consisted of three in total.....and incidentally, it works without the DISTINCT............

many thanks for all the help,....I persevered and came up with SELECT DISTINCT songs.songtitle,discs.disctitle FROM songs,discs WHERE discs.discid = songs.discid AND songs.artistid=1; and wey hey it works......

yes I can imagine, however I only want to extract data from two tables......the discs table (incidentally in error I omitted in my table creation syntax that the discs table includes artstid field also, sorry) and the songs table...apologies if I`m confusing you, it`s just that I`ve got the...

many thanks for replying, I`ll have a bash at it, absolutely understand about not doing it for me........believe me I have put in some work at this.........and can`t understand why I cant pull out the data required from the tables I created..thanks again..Elizabeth

I have created a database for a college assessment, the assessment asks for a database od a CD collection and therefore information to be held on Discs, Artists and Songs and that at least one artist must have more than one disc in the database…………it states that I must be able to extract a list...