CROSS JOIN SQL Queries; CREATE TABLE letters( letter TEXT ); INSERT INTO letters(letter) VALUES ('A'), ('B'), ('C'); CREATE TABLE numbers( number TEXT ); INSERT INTO numbers(number) VALUES (1), (2), (3); SELECT * FROM letters CROSS JOIN numbers; /// CREATE TABLE BLOODGROUP (GROUP_NAME text); CREATE TABLE RH (RH_VALUE text); INSERT INTO BLOODGROUP VALUES ('A'), ('B'), ('AB'), ('O'); INSERT INTO RH VALUES ('+'), ('-'); SELECT CONCAT(x.GROUP_NAME, y.RH_VALUE) FROM BLOODGROUP x CROSS JOIN RH y // CREATE TABLE SIZE (size_number text); CREATE TABLE COLOR (color_name text); INSERT INTO SIZE VALUES ('S'), ('M'), ('L'), ('XL'), ('XXL'); INSERT INTO COLOR VALUES ('Red'), ('Blue'), ('Black'); SELECT CONCAT(x.size_number, y.color_name) FROM SIZE x CROSS JOIN COLOR y; or SELECT CONCAT_WS('-',x.size_number, y.color_name) FROM SIZE x CROSS JOIN COLOR y ORDER BY CONCAT(x.size_number, y.color_name);

Thanks Naveen... By god the way you teach, I haven’t found anyone like you... You must get a national teacher award...Many teachers out there which may(maybe but I don’t think either 😝) have more knowledge but teaching skills are somewhat different....Wish you live more than 100 years, QA community really needs you ❤️

You’ re true gift to testing community! What a series .

This series is raising the bar even higher . You definitely should train other teachers/ trainers , how to create educational concepts enjoyable while learning. Thanks a lot 🙏🏼

This will help do a quick revision during interview calls, simply superb

Thanks Naveen really helpful 😊😊

Thanks Naveen.. really helpful!

Waiting for more videos on sql

Very useful❤️

Very useful video👍👏👏

create table MenuFood(name varchar(100)); insert into MenuFood values("burger"),("sandwich"),("hotdog"); create table drinks(name varchar(100)); insert into drinks values("coffee"),("colddrinks"),("juice"); select * from MenuFood; select * from drinks; select * from MenuFood cross join drinks; select concat(m.name," and ", d.name) as Menu from MenuFood m cross join drinks d;

Sir please tell about SQL statement like.. 1.DDL 2.DML 3.DRL 4.DCL....👍

SIR PLZ MAKE VIDEO ON SELF JOIN

When trying to execute in JDoodle-SQL online editor, im getting the following error " Error: near line 10: no such function: CONCAT"

Can we use conditions on second table. Select * from t1 cross join t2 where t2.stock > 20

There is a column with array of values in athena table...eg) col A row A has value like [{a:1,b:2},{a:3,b:4}] like this. I want to fetch rows which a has 1.how to write query for this.kindly help

Should I learn Kobiton?

Status change detected: stopped 11:08:32 [mysql] Error: MySQL shutdown unexpectedly. 11:08:32 [mysql] This may be due to a blocked port, missing dependencies, 11:08:32 [mysql] improper privileges, a crash, or a shutdown by another method. 11:08:32 [mysql] Press the Logs button to view error logs and check 11:08:32 [mysql] the Windows Event Viewer for more clues 11:08:32 [mysql] If you need more help, copy and post this 11:08:32 [mysql] entire log window on the forums I am getting this error .. when trying to run the MySQL from XAMPP control panel

This voice is not yours.i mean contents and tag lines r same but it sounds little faster, Like some one else is speaking.

I feel that Your voice changed a little in this video. Is the video a little fast forwarded.

@Naveen Please check my written query for your assignment CREATE TABLE MEALS(Meal_Name text); CREATE TABLE DRINKS(Drink_Name text); INSERT INTO MEALS('egg','omlette','bread'); INSERT INTO DRINKS('juice','tea','coffee'); Select CONCAT(m.Meal_Name d.Drink_Name) FROM MEALS m CROSS JOIN DRINKS d; i'm not able to run into xampp to see results but i try to write it on notepad and then typed here

CREATE TABLE Meals( meal_name text); CREATE TABLE DRINKS( drink_name text); INSERT INTO Meals VALUES('Egg Omlet') ,('Freid rice') , ('Bread') ; INSERT INTO Drinks VALUES('Tea') , ('Coffe') , ('Juice'); SELECT CONCAT_WS("-",X.meal_name , y.drink_name) from meals x CROSS JOIN drinks y;

select concat_ws(x.food1,y.food1) from food x cross join drinks y;