You can use "Union" select <<list cols>> from tab1 Union select <<list cols>> from tab2 Only thing is in both select sttaments number of columns and datatype should be same.
Forum Rules