Parsing large amounts of data together?

[JoshuaInayat]

Hi there! I've looked all over the internet for this solution, but I don't know what the technique is called so I'm not sure what to look for... Previously, I did this by hand. Then my computer crashed due to a virus attack and I lost my massive database. >:-<

Here's what I want to automate. I'm a photographer and I'm working on building a shopping cart for my website. The shopping cart code I have is somewhat limited to this style... What I need to do is this.

Table 1 has:
8x10 Print
8x12 Print
16x20 Print
New T-Shirt
Picture Mug

Table two has the name:
Oakdale Cemetery

What I want to happen in table three is this:
Oakdale Cemetery 8x10 Print
Oakdale Cemetery 8x12 Print
etc...

It took me 6 hours to do this and get it set up before because I didn't know how to do this. Is this even possible to do? Thanks for your help!

 

[Golom]

6 hours? There must be more data than that!

You are (I assume) showing the contents of the tables rather than the field names.

If the field names are
[tt]
Table1
Product
[/tt]
[tt]Table2
Location
[/tt]

Select Location & " " & Product As [Location and Product]
From Table1, Table2

will produce the output that you want.

 

[JoshuaInayat]

Thanks Golem! You otally rock. In my newb-ness I have just one more question... Uh.. where do I put that code??

 

[lespaul]

you create a new query, switch to the SQL View, and paste. Then correct the field and table names and then run the query.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[jebry]

Hi!

Don't forget to put some sort of condition to link the tables or you will get a cartesian join.



Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[PHV]

Jeff, the OP wanted a cartesian product !

 

[jebry]

Okay!

I didn't see that this was all the data the tables would have at the time of the query. That being the case then it will certainly work as requested.



Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[JoshuaInayat]

{Select Location & " " & Product As [Location and Product]
From Table1, Table2}

You guys are so much help, thank you very much for bearing with me here. My issue is I don't know SQL at all, and can't figure out which part is code, which parts of this to keep in. I've been playing with it, but... I know what it means, but getting the syntax correct I can't seem to do. Thanks again!

 

[JoshuaInayat]

The best I can come up with is this:

{SELECT ProductNames.Field1, Products.[Item Name]
FROM ProductNames INNER JOIN Products ON ProductNames.Field1 = Products.[Item Name];}

But, that creates an empty table for me so I'm still lost, lol

 

[JoshuaInayat]

Hey, I got it! They're in two different tables, I wanted them all in one table but I think this will actually work better for me!