Ask Your Question
0

Problem with GROUP BY

asked 2020-03-18 03:04:48 +0200

bbater gravatar image

System: Windows 10, LO 6.3.5.2 (x64), Firebird Hi. I'm having strange problems with GROUP BY. I'm following an [online tutorial] Video 29. His query, which works: image description.

But when I try to replicate with my table, I get an error: image description

Any help offered is welcome.

edit retag flag offensive close merge delete

Comments

Link above didn't work. This is it: https://thefrugalcomputerguy.com/grou...

bbater gravatar imagebbater ( 2020-03-18 03:06:36 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2020-03-18 03:35:47 +0200

Ratslinger gravatar image

updated 2020-03-18 03:36:12 +0200

Hello,

Not all functionality is set for using Firebird (especially concerning older videos)

Set the first column table name to (no table)

Best to use SQL instead of the graphic interface.

edit flag offensive delete link more

Comments

Wow! I'd never have thought of that. Thanks Ratslinger.

bbater gravatar imagebbater ( 2020-03-20 00:14:56 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-03-18 03:04:48 +0200

Seen: 50 times

Last updated: Mar 18