select * from mydata.sample_x1, mydata.sample_y1;
C 1
B 1
A 1
C 2
select mydata.sample_x1.x * mydata.sample_y1.y from mydata.sample_x1, mydata.sample_y1;
error
select mydata.sample_x1.x, mydata.sample_y1.y from mydata.sample_x1, mydata.sample_y1;
C 1
B 1
A 1
C 2
select x, y from mydata.sample_x1, mydata.sample_y1;
1
1
1
2
select x, x from mydata.sample_x1, mydata.sample_y2;
error
select mydata.sample_x1.x, mydata.sample_y2.x from mydata.sample_x1, mydata.sample_y2;
1
1
1
2
select * from mydata.pd, mydata.stock;
4 D A 300 식료품 1 2021-01-03 200
3 C A 1000 생활용품 1 2021-01-03 200
2 B A 200 식료품 1 2021-01-03 200
1 A A 100 식료품 1 2021-01-03 200
4 D A 300 식료품 2 2021-02-10 500
select * from mydata.pd, mydata.stock where mydata.pd.code = mydata.stock.code;
1 A A 100 식료품 1 2021-01-03 200
2 B A 200 식료품 2 2021-02-10 500
3 C A 1000 생활용품 3 2021-02-14 10
select * from mydata.pd inner join mydata.stock on mydata.pd.code = mydata.stock.code where mydata.pd.cf = "식료품";
1 A A 100 식료품 1 2021-01-03 200
2 B A 200 식료품 2 2021-02-10 500
