4 use Test::More tests => 3;
7 use_ok('SQL::Abstract') or BAIL_OUT( "$@" );
9 my $sqla = SQL::Abstract->create(1);
13 tablespec => [-name => qw/foo/],
14 on => [ '==', [-name => qw/foo id/], [ -name => qw/me foo_id/ ] ],
16 ), "JOIN foo ON (foo.id = me.foo_id)",
21 tablespec => [-alias => [-name => qw/foo/], 'bar' ],
22 using => [ -name => qw/foo_id/ ]
24 ), "JOIN foo AS bar USING (foo_id)",