Try quoting the date in the second select. Albert > On Jan 27, 2017, at 9:24 AM, Alastair Burr <[email protected]> wrote: > > I know it's Friday but can anybody see what's wrong with this view (an image > so that hopefully the email system doesn't mangle my layout): > > If it hasn't, there should be 6 columns so that I could see the columns and > data types (first 5 rows remmed out) more easily. > > I am not sure that I am defining the time entries correctly - I've tried with > as well as without quotes. > I am pretty sure I have the data types right - despite the error message. > I am not sure that I have the group by right. I only really need to group by: > T21.Concert_Date, T22.Full_Name, T23.Full_Name (date, venue name & artist > name). > > <mocadcidmmommmab.png> > > Any much much appreciated, > Regards, > Alastair. > > > > > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>.
-- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
