December 15th, 2003, 02:13 PM
SQL query brainfade
Hi everyone. New guy here.
Ok, here's a project that I have. I'm wondering if anyone can give me insight if it's possible.
Ok, I have two different tables. One contains a size code for an item we sell such as (along with measurements specific to that code, that are not important at this point) For information purposes, the table name is "size_data" and the value below is "size_code", which is the primary key in the table.
I have another table that contains that material data that they're using. This has a code as well of :
That table is called "material_data" and the value is "material_code", which is the primary code in that table.
Now, what I want to do is concatenate the values, but in every combination possible so that we can document every possible combination of the numbers.
For an output example:
Is a query like that even possible with SQL? I can't figure it out and I'm spinning my wheels.
I just want to take the first entry of one table, concatenate it to all the combinations of the second table.........go the next entry of the first table and concatenate it to all the combinations of the second table, and so on.
Anybody able to help me out on this one??
Thanks, I appreciate it.
December 15th, 2003, 03:57 PM
Try something like this: (not sure if it will work or not)
SELECT (s.size_code + '-' + m.material_code) as SizeMaterial
FROM size_data s
CROSS JOIN material_data m
See if that works...
December 16th, 2003, 10:08 AM
Thank you, that worked perfectly. Now I just need to keep applying that to 8 more designators........
Thanks again, it is greatly appreciated.