I have 2 table I need to join this 2 tables but I don't have common column in both tables .table structure as below
CREATE TABLE customer(
cust_id NUMBER
CONSTRAINT cus_id_pk PRIMARY KEY,
cust_name VARCHAR2(20) NOT NULL,
address VARCHAR2(40),
contact_no NUMBER NOT NULL,
email_id VARCHAR2(30));
CREATE TABLE supplier(
supp_id NUMBER
CONSTRAINT supp_id_pk PRIMARY KEY,
supp_name VARCHAR2(20) NOT NULL,
address VARCHAR2(40),
contact_no NUMBER NOT NULL,
email_id VARCHAR2(30));
question:
Create an SQL Query to list out all the customers and suppliers who have their contact_no as starting and ending with 9.