Hi Jack
I'm not sure if I understand your comment about two 'Ted' fields and
duplication of rows. In the example below there is 'Ted' twice in Table3 1
and 3 and must appear twice as I've shown in the result as the data in the
rest of the row is different. I agree with no duplication of rows if al
Hi Patrick
Thanks for your response. The tables that I gave were just an example and
there is no relevance in the friend/yes or names/contact details in
different tables.
To clarity, another example would be three tables - shop1, shop2 and shop3.
Each would have products so that would be a common
I'm having problems joining 3 tables to provide a 4th table in the correct
format. I believe I need a FULL OUTER JOIN but does not give the result that
I require.See below:
Example 1
Table: NamesTable: Friend
NameTel email PostCodeNamefrien
Hi Johann
I have installed Julia and I have a julia command prompt 'julia>' and I also
have Juno for JuliaPro which is an IDE.
I have loaded the file into the IDE and tried to run it. Initially I had
>julia csv_to_sql that produced an error - syntax: extra token 'csv_to_sql'
after end of expres
I am quite new to PostgreSQL and I am having difficulty with the following:
I am trying to input a csv file into a table that has a very large number of
columns. This means that it is impractical to create a table and specify the
name of all the columns. Can the column headings be taken from the f
