I have a table of image records in an MS SQL table TBLimages with a field imageFilename with 1,000 records.
I have another separate table of listing possible Fonts with no relationship to the image file with 100 records with a key field of FontId
I want to create an SQL statement that will provide only all the records from TBLimages but with an extra column for a random valid value of FontId from the Font table
But I don't want extra records created and cannot use a group by as too many fields in TBLimages .
Help would be appreciated.