Solved SQL to append new columns to table

[jaryszek]

Hi Guys,

i have 2 tables:
Table1

ID	Pet	Kind	Color
1​	Cat	Mammal	Black
2​	Dog	Mammal	White

and

Table2 Table2

ID	Food
1​	Fish
2​	Meet

What i want to do is to get result like here:
ExpectedResult

ID	Pet	Kind	Color	Food
1​	Cat	Mammal	Black	Fish
4​	Cat	Mammal	Black	Meet
5​	Dog	Mammal	White	Fish
6​	Dog	Mammal	White	Meet

so as you can see for Eech Per and Kind column (co Mammal and Dog and Cat) i just appended one new column = Food.

How can i write SQL to do it?
Best,
Jacek

 

[jaryszek]

Hmm and it is not possible to do this without additional tables only with SQL?

Thanks!

Best,
Jacek

 

[jaryszek]

Thank you,

let's wait i want to know it And will decide.

Best,
Jacek

 

[June7]

A Cartesian query can produce the output you show (except for the ID field). What purpose do you want this for?

SELECT Table1.*, Table2.Food FROM Table1, Table2;


BTW, correct spelling: "meat", not "meet".

 

[jaryszek]

Thank you Guys,

i needed cross join here,

Best,
Jacek