Simple SELECT statement query with error

Question

It is a simple SELECT statement where i pick data from two tables

SELECT 
    bookingid, customerid, flightid, numseats, 
    passengerid, firstname, surname, passportno,  
    nationality, dobdate
FROM 
    flightbooking, passenger;

I get an error:

ERROR: syntax error at or near "SELECT"
LINE 9: SELECT bookingid, customerid, flightid, numseats, passengeri... ^

I am using PG Admin 4.

Tip of today: Switch to modern, explicit `JOIN` syntax! **Easier to write (without errors)**, easier to read an maintain, and easier to convert to outer join if needed! — jarlh, Apr 17 '17 at 18:16
However, your syntax is valid. (But will probably not return what you want.) — jarlh, Apr 17 '17 at 18:18

score 0 · Answer 1 · edited May 23 '17 at 10:31

0

You have two tables so you should use inner join please check this Mysql SELECTIONG FROM TWO TABLES

edited May 23 '17 at 10:31

Community

1
1

answered Apr 17 '17 at 18:24

Mouad Abdelghafour AitAli

350
2
12

score 0 · Answer 2 · answered Apr 17 '17 at 18:28

To troubleshoot, start by changing your query from this:

SELECT bookingid
, customerid
, flightid
, numseats
, passengerid
, firstname
, surname
, passportno
, nationality
, dobdate

FROM flightbooking, passenger;

to this:

SELECT 1 bookingid
/*
, customerid
, flightid
, numseats
, passengerid
, firstname
, surname
, passportno
, nationality
, dobdate
*/

FROM flightbooking join passenger on 1 =2;

If it runs successfully, change select 1 bookingid to select bookingid. If that runs successfully, uncomment 1 field at a time until you get an error. The last field you uncomment would be the cause.

Simple SELECT statement query with error

2 Answers2