Create view query not working .

[pankajit09]

The following query is not working -->

create view citydptjoin as select * from segcitypair,segdptret where segcitypair.ticketnostarting=segdptret.ticketnosta rting

Please help.

[cnplnsk]

Hi ,
I am vijay kharde from cnplnsk
As per my information you can't create view in lower version of mysql 5.0

Views are currently being implemented, and will appear in the 5.0 or 5.1 version of MySQL Server.

[pankajit09]

Hi ,
I am vijay kharde from cnplnsk
As per my information you can't create view in lower version of mysql 5.0

Views are currently being implemented, and will appear in the 5.0 or 5.1 version of MySQL Server.

Hello Vijay,

You are right.

The version here is old.

What is cnplnsk ?

[pankajit09]

When I fire the below SQL I get the error -- Duplicate column name 'id'
I have put aliases still why the error is coming.


CREATE VIEW citydptjoin as select cp.id, cp.departcode,cp.traveldate,dpt.id,dpt.itinerary,d pt.departdate,dpt.returndate from segcitypair as cp,segdptret as dpt where cp.ticketnostarting=dpt.ticketnostarting

[ScarletPimpernal]

Hi pankajit,

Try this query

SELECT version();

If u get the version 5.0 or greater than 5.0 then u can create Views
Else No ...

The following query is not working -->

create view citydptjoin as select * from segcitypair,segdptret where segcitypair.ticketnostarting=segdptret.ticketnosta rting

Please help.