View Full Version : How can i do this with SQL (pictures)

08-27-2002, 01:41 AM
My fake online cd/vinyl store. Trying to setup a good search+results+details system. I am **** at explaing and it's easier with pictures so i made these:

The tables in my database.

What i am tryng to do.

I have done some very basic search and results before but not with more than one table like this, i am a little confused, i can layout/output the stuff with CF fine it's selecting it and getting the search working well that's the prob.

(using .cfm pages)

Any suggestions would be lovely :confused: