MySQL 5강

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