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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
mysql query please help
yes this particular query extracted from only two tables but the database consisted of three in total.....and incidentally, it works without the DISTINCT............ -
mysql query please help
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...... -
mysql query please help
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... -
mysql query please help
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 -
mysql query please help
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...
