Hi, I willike to add independant column to my table (Not included in the table) Exemple Table Artists (ArtistsID,ArtistName, ArtistsDOB) Table concerts (ArtistsID, ConcertDate, ConcertLocation) I want to produice SELECT a.ArtistsID,a.ArtistName,c.ConcertDate,c.ConcertLocation From Artists a INNER JOIN Concerts c ON a.ArtistsID=c.ArtistsID
What should I add to get Rep=Manager (Rep is the column mane, Manager is the column Value)
I'm even less sure that I'm following your requirements BUT if you want the literal string "Manager" to appear in your output, follow Lamprey's advice (usually a good idea anyway). If you want the name of the manager to appear and a Manager typically is attached to a single artist, then add a column to the Artist table using the ALTER TABLE command. If one manager has multiple artists then create a Manager table and define a foreign key relationship by adding a linking column in the Artist table using the ALTER TABLE and create the FOREIGN KEY constraint. If, on the other hand, I have completely missed the point of your requirements, ignore this post in its entirety.
================================================= There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber