|
|
-
darkiostream Replied 2 Years ago through ASK | 1 Point
What I need is to create a search query that can do the same thing but.. without the 'COKE ZERO' in the result....
![]()
|
0
·
0% ·
0
|
|
-
darkiostream Commented 2 Years ago through Ask | 10 Points
What I need is to create a search query that can do the same thing but.. without the 'COKE ZERO' in the result....
|
-
darkiostream Commented 2 Years ago through Ask | 10 Points
Select ICode,Descri, SName,Price FROm Itemtbl,Supptbl WHERE Supptbl.SCode=Itemtbl.SCode and PRICE in (Select MIN(PRICE) from item_tbl GROUP BY Scode);
That was my search query code:
and the results looks like this.
Icode: Descri: ...
|
-
darkiostream Replied 2 Years ago through ASK | 1 Point
Select ICode,Descri, SName,Price FROm Itemtbl,Supptbl WHERE Supptbl.SCode=Itemtbl.SCode and PRICE in (Select MIN(PRICE) from item_tbl GROUP BY Scode);
That was my search query code:
and the results looks like this.
Icode: Descri: ...
![]()
|
0
·
0% ·
0
|
|
-
darkiostream Posted 2 Years ago through Ask | 10 Points
I have this in my query:
INSERT INTO Supptbl VALUES ('A2','Del Monte Farms','Quezon City');
INSERT INTO Supptbl VALUES ('B3','Coca-Cola Bottles','Makati City');
INSERT INTO Supptbl VALUES ('C1','Nestle Phil. Inc.','Pasay City');
INSERT INTO Supptbl ...
|
-
darkiostream Posted 2 Years ago through Ask | 10 Points
I have this in my query:
INSERT INTO Supptbl VALUES ('A2','Del Monte Farms','Quezon City'); INSERT INTO Supptbl VALUES ('B3','Coca-Cola Bottles','Makati City'); INSERT INTO Supptbl VALUES ('C1','Nestle Phil. Inc.','Pasay City'); INSERT INTO Supptbl VAL...
|
-
darkiostream Question Asked 2 Years ago through ASK | 2 Points
I have this in my query:
INSERT INTO Supptbl VALUES ('A2','Del Monte Farms','Quezon City');
INSERT INTO Supptbl VALUES ('B3','Coca-Cola Bottles','Makati City');
INSERT INTO Supptbl VALUES ('C1','Nestle Phil. Inc.','Pasay City');
IN...
|
-
darkiostream Question Asked 2 Years ago through ASK | 2 Points
I have this in my query:
INSERT INTO Supptbl VALUES ('A2','Del Monte Farms','Quezon City'); INSERT INTO Supptbl VALUES ('B3','Coca-Cola Bottles','Makati City'); INSERT INTO Supptbl VALUES ('C1','Nestle Phil. Inc.','Pasay City'); INSERT INTO Supptbl VALU...
|
-
darkiostream Question Asked 2 Years ago through ASK | 2 Points
I have this in my query:
INSERT INTO Supp_tbl VALUES ('A2','Del Monte Farms','Quezon City');
INSERT INTO Supp_tbl VALUES ('B3','Coca-Cola Bottles','Makati City');
INSERT INTO Supp_tbl VALUES ('C1','Nestle Phil. Inc.','Pasay City');
IN...
|
-
darkiostream Posted 2 Years ago through Ask | 10 Points
I have this in my query:
INSERT INTO Supp_tbl VALUES ('A2','Del Monte Farms','Quezon City');
INSERT INTO Supp_tbl VALUES ('B3','Coca-Cola Bottles','Makati City');
INSERT INTO Supp_tbl VALUES ('C1','Nestle Phil. Inc.','Pasay City');
INSERT INTO Supp_tbl...
|