Ok.
I have a number of records with information about photos. Each one could correspond to zero or more motivetypes from the list.
A photo is identified by two integers, photonr and photonr2.
I want to use this relationship as if there was only a single primary key in the [photo] table instead of two.
One purpose with the relationship would be that when deleting a [photo] record, the corresponding...
chrisbo
Last Activity: Jan 10 '11, 10:37 AM
Joined: May 10 '07
Location:
-
Many to many relationship problem
I have three tables and want to create a many-to-many relationship between them. The main table [PHOTO] has a composite primary key
This can't be done, though. The relationship between [Photo_motivetyp e] and [Motivetype] is easy, but I get this message as I try to connect Photonr and Photonr2 in the tables [PHOTO] and [Photo_motivetyp e]
It feels like I'm missing something here. How can I do to... -
Update/Insert with constraint
I have two tables in SQL Server 2005: ImagesMain and ImagesNew. They have the same structure:
ImagesMain is a listing of all images on a server.Code:FILENAME WIDTH HEIGHT LASTMODIFIED 00328.JPG 757 275 2007-05-08 09:40:25 01_806.jpg 567 423 2007-10-03 10:16:57
ImagesNew contains a listing of a subset of the images on the server. It contains:
-Items that exists in the main table... -
Combine values
Hi,
Using SQL server, I need to update a field in table A with a combination of one or more values from the same column in table B.
Example:
A
Col1
field1
B
Col1
John
George
Paul
Ringo
The result in field1 could look like this: "George, Ringo".
(I will use a select statement to extract which rows from table B I want.)...
No activity results to display
Leave a comment: