Sql server中如何将表A和表B的数据合并(乘积方式)

时间:2022-05-24 01:06:23

sql server中如何将表A 和表B的数据合并成乘积方式,也就是说表A有2条数据,表B有3条数据,乘积后有6条数据,

这就要用到sql中的笛卡尔积方式了

1、什么是笛卡尔积

  笛卡尔积在SQL中的实现方式既是交叉连接(Cross Join)。所有连接方式都会先生成临时笛卡尔积表,笛卡尔积是关系代数里的一个概念,

表示两个表中的每一行数据任意组合。如果分步骤理解的话,内连接可以看做先对两个表进行了交叉连接后,再通过加上限制条件(SQL中通过关键字on)

剔除不符合条件的行的子集,得到的结果就是内连接了

2、实现方式

--1、创建模拟的数据表---
--1.1)产品分类表
create table GoodsCate(
Mid int not null,
Code varchar(10) not null,
Name varchar(20) not null,
)
--1.2)产品类别表
create table GoodsLevel(
Mid int not null,
Name varchar(10) not null
) --2、添加模拟数据--
--2.1)添加产品分类数据
insert into GoodsCate(Mid,Code,Name) values(1,'','电子仪器')
insert into GoodsCate(Mid,Code,Name) values(2,'','激光仪器')
insert into GoodsCate(Mid,Code,Name) values(3,'','扫描仪器')
--2.2)添加产品类别数据
insert into GoodsLevel(Mid,Name) values(1,'Ⅰ类')
insert into GoodsLevel(Mid,Name) values(2,'Ⅱ类')
insert into GoodsLevel(Mid,Name) values(3,'Ⅲ类') --3、查询数据表--
select * from GoodsCate
select * from GoodsLevel --4、简单的笛卡尔积使用--
select * from GoodsCate A
cross join GoodsLevel B

3、显示查询结果

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAALIAAAByCAIAAAB4AByLAAAKJklEQVR4nO2dvY7jNhDH+U5CitW7BIc0fJBUKVUtoM7FYpvLNT5AtesVg5RGILhaHBAYe4CdajumoCxT/BiORMqS5flDWMgyxeHHTzMURWvZCa2/SA8jRliQbA3AgvQ4YhsSyRJ5C5JDhAXJIcKC5BBhQXKI/XNXmru5HkVM3o8Ii5vpzrBYvubu0DS6Myzmbq6All9CpEwseCmcW8bNbQlY7Ha73W637WuzeZmlKU/rxqIUst1KyT0bjAVjDPiYEIuyNItxPB55Wc7SlKd1YxH0ExkXWRaFBfNrHBbn81l8SPEhX99OnBMWsTK7Qb/+6rru9ne7ndr5/PwsS5FlPMgE0Ot69/v28Vjs93shRF3Xr2+nshSRWDDmncsBvlJ6CCw6FKSU2+1WMXE+n8tSPD09BZkAOjuhtyiF2G63ZSk2mxe1DcKi62l4xycjt9Visdm87Pf7uq53fammVwM6GAu7d51YBPeRWBhpXt9OrdsQohTicDiEm6DPgf7XSOA7sdOasej2dW9RluJ8PqsQvtm8+LAwetfnCRJ6i/f39+PxeDwehZCvb6fXt5Ne5izjGDJ6LWJ1NnkLdxD5/PzcbrfdsA7GAu7amPROLA6HQ8+lCaGqIUtelqKua4AMwyX4ep28hXx+fhZCqFbuwrb628XvsiyDQUR1ttMTABcf7DAwQaTFQkop5eFwyDjPMp5l3Ft/f98zGlvoWFybuBRqjHk+nzebF/EhlaN+fn4G7kQMSpz7+hH9LywfFsqNHY9H8XHBouSScyklL7OyFBn3YnFtCPIWmiAsVODoxhNd8A5ioXsLHxbMumcJkgFgoZgQH70geD6fD4dDKQTgLa4NQd5CkwOL7r5DDxzqBuT5Ih8WRhRwRgc7je90JBYdE0JcsOBc8uz9/Z2XWRALdrn1CPb6ye85lNaMxdPTU5Zx46++owRc1r4uD6aBFcBCSC6y7k7qeDzu9/vdbqfuR7z1x40tnCkfyFssWU4s6rpWk1pqa7HgmeRZXdcZzwAsGDg54cMCOEhYzCAnFhnnX758yThXm8Kinc66BMERY4suiBjoGCGGsJhfmEZXENjbDZryRFjMouU3+vJLiNSdYUG6je4JC9LNxL5++04bbcbGvn77Pil3P378uOv8l2Y3oYAqEBZ3ZjehCIv12E0owmI9dhNqYVg0Rc4Y41Xvc1409slNkTuPw/lL2RQ8VzORec4rOAOUFZTdpsj1aozK9pZaHhZ5fm0yRUleNHY7jsJC9U4LQ1NxN3HDrGDsXisSke0ttUAsioJf2qziOefuFhyDxfDeSIhFXhQ8b/0gYTHMtmqvquWi4nlRFbnuLS4xIM/z4KVu5u/rjC6uXHrNYUVLE+xPb720WuRdDduHazmv1HHOufIsVcFzxi6RbkgB4rVILNpWq3i33x5pipypZsJEABwWWp5FztrOMaxoZ44b01zOqnjX/a6Y2A1B9J3hBYjXIrGQTZHzSjWhjoXeIiO6x3mKnafzSO+xecAwgIXUWZfKB+TXXG13MqoA8VomFu3Q83phJcHCeQ4Wi+vdUUy95CVQtO6wGwD7osyoAsRroVh0Dr3fXn2Hn+ZOBAwirZWmyFkb0uOCiJRSyoq3F3zFr7lyyFsMLEC8loqFcaSHixp45WO6R5+3cIzm+jfGupWmSjDk1D5dRg6XXNXY1ovFsALEa2FY3FX+S7ObUITFeuwmFGGxHrsJRVisx25CERbrsZtQASwmX0ZsvU4k7V/SOAHEtFhMwGKr0+n078//ptvwv1VMXq9Z7KbS/FgwxqbDYq7uISxizZO3WKDmx2Lp3qJpmuFTihi7SZBl4Ps/9Gdr9kdAEVg0BY9+eBPwFuKPX9lvrxN5i8q7xKKbW654zliea2mQFY/HgrkEZ2InMKCBGdI1DovuKW8CLDze4u/ff1EmorDwV6/i7PIgjvefjnXrOK5PMaznMWOxcHY25vINMiFdvT6Ht5DV5N7i559TeQt7CY/2KKutmFa/flXDFQewCO7DZ9nHASfhPIgJXvNjAY4tYrHwFd61eqFb6OFYP9V//HlTLAAmxmEBm1OaH4tZvIW2YlIbN7SLztsDE2ExNIgAfex0AM4IMjRszY/FfN6iGzewvnOwF0/e1FvguxPGwraLCR9w+dvc1uotZMWNLndAsIyxBfIrIKDYzHnLfdH8WMziLdrC6+v0roNQr//AV3zqIOL8yv7oO/cOgsg83kI65i26X2z0j1jzFhN4C98R30Ffbk4yOgiQAwug/G22NMt5y1nO0VgEY5MBzR1gMR0TAW8xpZCNBocSZHwB8CJvMZm3GFuvWeym0vxYPLK3WKzmx4K8xQKFwmJqMVq3tzyFsUjN4lWTZn6D/JdmN5UIi1XZTSXCYlV2U4mwCOkm01njJr9laIbq1vMW13niuN9OA+aTmICqN2rRHrJUPrv2RJNx3P4I04P89iaznPpLGeJexuE1n8iEv3qjFu2hSwU0q95DvmlK6epCmAnfKfPMcka+gQPjbGNMQNiNX7QXLlWwXpjeQqITxMU4GGQiWP4gFpN5i0QmfPnHLdoLlwqDhew/4Pb1FnB8HBZAnp2isMC8pijGfLwJAIuIRXvhUg0aW9iBH5bzFMAEkM/Q8rc5A1g0RfgdRUGFI9Q02MUs2sOUKji2sHfgix4fFwaFG59GYhHvJ4Lmk5gAxhbjFu0hSxVoVvDS15M594EEzkyMZBg4RmGR7mWAXvOJTIB3IsMX7aFLhRxb+D7aB4MJnB99BEwSRCreC1FT3ImkMjFo3iK4aA9fKswNqt43sKuQiHjh9Ba2W8IMLODyS5rllDLxLKdzPGH3KECJMxnMim2CsFjiMxGnw5CeK17/Fple737yFjPkvzS7qURYrMpuKhEWq7KbSigsSA+oMBapWbxq0sxvkP/S7KYSYbEqu6lEWKzKbioRFiFNsGgvOG0gEVNVQDL925vOW1gTxyMFmE9iAqpe1KK9QKmQWDBLRho7gdGjg6CZeJaze6rUxL7LwGs+kQl/9cYu2sOVapy3cPYx0PG+j7PPcsb+1yyEk48yEcbOZQexaC9QKp9d4LqXLg8BVE1aPsA47jsYzBYof5tDAIvox99hLOJM+PKPXbQXKlUqbwEEEd0HYPKHw82w8sOrs9iUPwhIYgIo/OhFe5hS4bHw+Q/faEA/DgcaJ1JIVxQfRO53ie/oN+2FSxXEAggizjRBApyZGAcx4QNV/hX/ICDiTXvhUgXHFr5vjTTwVQ54F8Oi7+PQ8reZOLHoxuzTeYtUJsA7kcGL9vClSji2ML4CHIP9ETA0RRBJ9o9a/ebTmBg0b4F40x62VLfHwuktDB+DHFiEy0+znJPOcgYDBDKIwKxIP2Qjy09YJLcL+3YjjXOsYOwDachbzJP/0uymEmGxKrupRFisym4qobAgPZpgaCb/Z9qkexRhQXKIff32nTbajI1egUtyiLAgOURYkBz6H3fKzdOJ7K3CAAAAAElFTkSuQmCC" alt="" width="178" height="93" />aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJMAAABgCAIAAACWgdf1AAAETklEQVR4nO2dPY7bMBCFeak0vEuKNDxIqpQ8RZokVQCeYoHUBusF0ixg5AJMQVmiZOrHnBmKQ82DsbCNNR+Hn59ES5StbrdbeOgu4iMl5JhKyHHVjNyPX7/lxuW2JBco9f7+zrr9pjog5Lh2QMhx7YCQ49qBs8l5q5VSxs0ea+ufX+ytzj6/337ysgONQHQxclpPoxlBauufh7icXPJWEHJlWiFnrXkMpzPamPzgFpPT1ho9pFrIlWltZL0b0DmjrbM6zZy3RiullNY6vxU90n7Smh6dVJQ2Lj5vjIn5dNZopbRxPiQdUNrsMr8euWFAnRnvD894q1UcQe9MObkYZpfL3GgXW0/vDB14vKAs9GRqg1zwVhsXRzcllw4WYGvpQwjp2yLEJI2py4VyIppqpwcXJDfMVKZY4JMbtohDuJW2j41hfnM6kZsmviUFkqkVcmEco7WtpQXs54YHzgyxcUYNOy1vzVbmYgesf2rqcAfI1Ay5xTMzonF+oIGZC7O92GPaESc+q+RC8E5mKHIMBVNCjmsHhBzXDgg5rh0Qclw7sCRHvnpCKdK/56oatjw5OrP7/f734x/dTSlF1/kj1dW0q01OKUVHrvLYPVdX004yh1ldTbtLZw6XdKvkvDWvHHvNaidzb98+qy/fKTI3PwY2/tvzHWB18EaO6wi58VQHArmVzP35+ilagMhtvO0WxzwjqvQvXA2Si3Lkmfv4SZ05tSdgdZCXv6ra5Db3c1BykrmsesjcUPNl9nNRnWRuDRIcXufkWsjcVPwlPhV0kTmZoRSqqczhTk9Cw+QQ1MgxlEW84Gkbq4M3clzXOm65AanjrSWCGskcXXU17a6VOVJ1Tk4yh6XaqxnuXS9oOJkcnRl1bZXH7lx3IcfVXchxdRdyIXR8rmC8NBd4jfVGbSgWq+2n1z8mx/BwT/e0Ry692Oyl6wCftFobksWr5ALqKdb2yCUCfrXBkdogFsfJUZw0aJkcWeaQLCRzeR253ndbu7UBLWQ/l5G3+xf77mp/U0z0zsiRQ1/W0CI5eNqiSAO91f761jKq008F0L3bpK2RxbCQGcpMzsxKophbYlmUZQ5lerLlTqNLH0NZxKs4bWXuQF2U3AakfraWiGqHXAfuQo6ru5Dj6n7CaoaOdTI5OjPq2iqP3bnuQo6ru5Dj6i7kZurtk/j03ZywY4sbtaFYrLafOfqFf7qnPXLjl5Z76IVYq7UhWRSTCxinWNsjNwn6Ow0HagNZFJBDPGnQMDnwuZj92mAWkrmMFr9vU6bt2uAWsp9bU08riPCXNbRMrp9VexTLGpojN/3YA1nmsCxkhrLQK7+1sKn12nAsgJkDLmtokByamj2GgrKsQchVbR9xWYOQa7f9ptyFHFd3IcfVXVYzoKkmtgy5yvaiYgk5rhJyXCXkuErIcZWQ4yohx1VCjquEHFcJOa4Sclwl5LhKyHGVkOMqIcdVQo6r/gNRMDH6kNBlKAAAAABJRU5ErkJggg==" alt="" width="147" height="89" />

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPcAAADICAIAAAC7wuB8AAAUBUlEQVR4nO1dT+7zuA31pbrxXbroJgfpqsucopvprAbIKQr0AFkP0M0Ag15AXSS/RJFE6omkbDPmw4cP8Z/w0eYzzVjmT0v6wS+//pYCgW/E8vr0y6+/xb/495X/3ir/MxD4UoTKA9+PUHng+xF1efz7/n8fKp/1EzellNLvv//u2v7ReK0w1f/dT87DgVC5V14rhMrt+fzaPxqvFULl9nx+7R+N1wqhcnu+D9yv67Isl9vH8nq911++X9fmet5+SvfrZV2WZVmWdb3ceAMQC8R7v675YYjMboapcdn95BxD5ev6PsjHyV2v9/rIRSp/nM+ntu+3SztQYywI7/tAFGY3w9S47H5yDqLy6/Xyc5S3y3q5tI9ZovLx82eo8vV6vazPbOhS5TZx2f3kHEXl99vzdN4u6/V2XfOc8VNwrOvaTcSlfer0vYqYn/PcYMn26UaAPK7sKNbXES7Lm/t+XdfL5fJIbbfrZV2Wn7JqxAElpsZl95NzGJU/j/N2eX1+rrlf1+VxYEi5gak8s3ldl+fpLFiyb8p+D/x863Z5Bax1o39VqPmHcQeUmBqX3U/OYVSe7tf1cnscdH4282MQqK35ldpmc82So0PMBDLlEkmPJLS+rdb5TOSAElPjsvvJOY7Kn7923le2icqb30FV/n6+oDmu9HPjfSbF129h6q4tckCJqXHZ/eQcSOWv6uHzCD+ri/HK4d54xsJWLE+W+3VdnhWfrmJJKaV0uzwzzu3ytnrh0tWgA0pMjcvuJ+dIKi/WfJzlx8+MVaK27IdK67fL55OynOV+M/j1mS39FJY/Vh8/2shAjjmgxNS47H5yDqByV/aPxmuFGPu05/Nr/2i8VgiV2/P5tX80XiuEyu35/No/Gq8VQuX2fH7tH43XCqdT+fT2u2WZ+n8gUOCh7VLl866qP//8879//G/ev2VZ+k7MOa5deK0wO+jzjOPsm6p8WZZ5Kt/rhIbK9zKOs0cuNziuXXitECo3pjx6Lr/f7+MDjQivyRX4MtK0lr/BVC8yOJTKbVPVoMrv14v6/aFOLv/3P/66/O2fk3L5jXyl/DVGfLusy7Ku2T7ggetVvrTAG6l3KK4B/pLI0fFfF3pGUfk4f+2tidxxlb/edDRQOZHL//P3vzwoVCqno3W7LD/vHF0+X9B6vR/9PunVuxpSlTe1iyTXrsQTIQvrXG4QelDl6fPitMrooxXLbXou/+Nfs3J5/aZ/doqfB5Yd3+eh9g+cUXn3M/+tej2TwpsrEbn07kWq0HdVzuQC5BIF2TdVOZHLbVROOd96Ifn1AnWjYeUzy2yqckbiMpXzdA/sq/IXIpercvn93UCY1dyPBoH1uWKSykfzEyPZZnpuliujGfEIKq+PzkToZ8vlr5p7+Uzd7zfzd8nluDp5lde8uEp2VzlzB5PSluzfn8vT7VIouKHpY9Tl4CameqkvIdLvH+yu8hxWtUrB/v25/Ol83uD1/j1KZnf8wGdXLM1N9SKTEY9cseB3Mw37CXJ5ajwvf/3xj8811fPyCbmcWkOtpKw1hf5SBi6U4+Ty0VoLZ4+xzwwbjn2KVd4thAqtqFWuAmhcVmvh7PEei8FxIbvx92KwmGGulmm5XIWuccbD7SsWAzjI5dLj2oXXCkfI5bPZI5cbHNcuvFYIlRtTRi4/IM6o8tlYoikusCHaKt/gwnJq/2i8VnAddJA9VO6V1wqugw6yh8q98lrBddBB9lB5hk1GhcABTmYrNaLk8Xl5AdsHZQMqfw+G6/76KnPAJhTcCRV1xIFeUbz1eE2xvl7kLwZwazF+pFX5KTri8r8rrfvb8eQBG1HQ0RJ1xMFeMSrJBUcNXiYsxtS1MXPs83QdcU3HhJSTKLirSN4R1/eqe1yI+MAroav+YiUil57/J3onMU3M5UYUlH1dR1zfK0Tl6fOtDCp4zHqZyhmbL+yr8hcOkcuROU9AykkUjMoVHXF9r4bq8rpo7may+isMhSAjHkHl9dGZCH1M5fdrf8ITnHISBZvLhR1xiFfdurz+wKdkPj2De+Iq2V3lo3c2AXtf5fosXlBOomDqcllHHOgVrxI+Mee7NT8zOzSNFLshQtld5TmsapWCvadybTXeoJxEwT5jGe+Ig70C63JqsV7Z3aG5yGTEI1csmloLZ++o/Hb5oJzxjMWKYuh5ebcjDvcKeZKYB4xP5PkiJf1mLq9vGqBQjpPLm8elQYx9tmA69lmItf6/2I36IrKSomvaB/03AWi8uBr1WbxgD5XP5W2m89TLW/j+uZrn5HIVwMGE0U2j7KFyr7xWcB10kD1U7pXXCq6DDrKHyr3yWsF10EH2UuWBwDehrfINLiyn9o/GawXXQQfZQ+Veea3gOugge6jcK68VXAcdZA+VZ5jQEYc88e2O+DC75Vs9Pi8vYDjwmYZUXo2OayknUXAnVNUR1/EKVPlSodin3qEI+dA1wF8SuP+n6Yh7Tpmm/ePO5AEbUdDRknbEYV7JcnlTsoyOqcWZY59n7IhTNsSBvUJyiv5V1OIBOuI6XlG8TFZOrfzNHFqiw9/84lBG7MXlBO8kfrg1KZcbUVD2tR1xPa+scjkT4zxDI/aZe8Ko/yfqiHvcuub9pQoTCsZ5cUcc4hWucipLFaEtPlBbi5XijHgElVPHroSsYvHb3SyeI67vVVflTZ011V9sogTdNFKsxFWyu8qR252SfeBJot+/VKGYI67vVbcup7YW+/A5mMn9BSO1OOr/D07QEfd6GjEvl1tRsM9YhjvicK8M6/JiE5O260WG6MgVi6bWwtm7ufz+fmw8qy63oRh6Xg7MEYd6tb3Km7m8UAYulOPkcuoeJUaMfbYwc+yzW43wmQyUfqKvGZn/SoDG64M10XqofAteJlqF+lNLjt38XduZkMtV6BrnT5FS66Fy97xWcB10kD1U7pXXCq6DDrKHyr3yWsF10EH2UuWBwDehrfINLiyn9o/GawXXQQfZQ+Veea3gOugge6jcK68VXAcdZA+VZ9hkjjgx+IEep8/LKewzKlS3Iogp29B1XnXsizriQK/0KudHPZtG+OGhepEBG3Tt3H2k8fcI/8cbBLXbGrkPqvx+XSe+X27QecXaF3XEwV5RvE3tIsm1K/FEqME4l1vM3Teq8kS8VS/DkMoffQjaOVd6OW9+X+kLAx1xfa8YlXc/89+q1zMpvLkSUQlyLxK/EY2rnEkKyLXKswMqv13Wy03b9bmfynUdcZuqnJG4TOU83QOAyr8/lzd0oKQkMFHlijniVCofTUuMZJvpuVmujCbCrso1sz75qMvzKtWvyhUdcXNzOa5OXuU1Ly4OPi7KufuGVM7cypTsvMpfv8CemNkRN7EuV3TEHaJiaVqod64vDEQfTFz0c/cJKpYHNCm8ZkefJPrN5cI54mCvZlcszU31IpMIhRWLxdx9fn59Fl5JsZ/KZR1xqFejuZxaQ62krDWF/hIErg/Kf5O5+2S5nLpZidlj7DPDhmOfYpVTF0+xQ3P/Jg4V9OKyFGfxgj1UvhEvfwvu5l0qveVqts3lJsCNM65uV7HocXKVHxaugw6yh8q98lrBddBB9lC5V14ruA46yF6qPBD4JrRVvsGF5dT+0Xit4DroIHuo3CuvFVwHHWQPlXvltYLroIPsofIMm4wKgQOczFZqRMn18/IC+oHPNKLyfKB31rxC+s4r3r5ujjjhXBT1eE2xvl7kLwZwq+HY53k64rSvl9SULQZt5xVnXzxHHOYVo5JccNTgZcJCS10bE8c+T9QRp39Lq6JkMGkuCt0cccK5KF5AxAdeCV31FysRlUyNC67ypQcNO6DyZV1XbTmRoLM5b14hxRxxurkoUibQrviY9TKVMzZfmBoXT7n8eXOfPHuW8p19RuWKjri+V0N1eRE8JIHVX2EoBIlwaly81OUtx3SUpPE5bSmajjjEq25dXn/gUzKfnsE9cXFMjcuQykdvcTj7IVSu77zi7Es74kCv+JPGJ+Z8t+ZnZoemkWI3RB9T4yKoWB5Q1ioFe0fl76nS7vWPOCFlCYvOK86+rCMO9gqsy6nFemV3h+YikwiFFcuZOuKmzxFn0nnF2H9wjHbE4V4hTxLzOPGJPF+kpN/M5fVNA9TH1LjIcnnzADXsAxWLFeVx7ZuOfRZirf8vdqO+iKyk6Jr2Qf9NMGq8uCzFWbxgD5XP5W2m89RLV/j+uZptc7kJcOOMq2Kth8rd81rBddBB9lC5V14ruA46yB4q98prBddBB9lLlQcC34S2yje4sJzaPxqvFVwHHWQPlXvltYLroIPsoXKvvFZwHXSQPVSeYUJHHPKgtzviw+yWb3X9vLyAfuAzjam8Gh5XUk5i4E6oqiOu4xWo8qVCsU+9QxHpoWuAvyRA/0/VEffZTqambDA857tQdd/R0ZJ2xGFeyXJ5U7KMjqnFiWOfJ+qI08/zWVHSUL3b27+KWjxAR1zHK4qXycqplb+ZQ0t01JtfHEqESFHx5R1xRm/FflCS0JFR9rUdcT2vrHI5E9o8QyP2mXvCqP8ppe/P5e12Mh1lE48ZjGZ0aWg64hCvcJVTyamIaPGB2lqsFCfCrsq/vyOu0U6mpqQxr7tZPEdc36uuyps6a6q/2EQJummkWImLo5t9TtARV7WTyfjS5PqPs6+aI67vVbcup7YW+/A5mMn9BSO1OOp/Ok9HXKOdTE1Z4N10N/GvDg13xOFeGdblxSYmbdeLDJGwYjlTR9wGz8ttmu6GnpcDc8ShXm2v8mYuLwSB64PyPzriVJTHtT9z7JNJTrUuqX1ST/qJvmZk/isxarw+ao3WQ+Vb8DJBKtSfWnLs5u/ajmEuNwFunD9XMq2Hyt3zWsF10EH2ULlXXiu4DjrIHir3ymsF10EH2UuVBwLfhLbKN7iwnNo/Gq8VXAcdZA+Ve+W1guugg+yhcq+8VnAddJA9VJ5hkznixOAHerw/L6ewxajQ49XTDDN6eZ5Mymm6OPuijjjQK73K+VHPphF+eKheZMD4r3+3gzTeGOG3fwVXlMvvV82rLLTx16U0SeWijjjYK4q3qV0kuXYlnggRGOdyi05FscoT8Xq9jH1A5dkbrBL0cp52ysV+tF4Y6Ijre8WovPuZ/1a9nknhzZWIOIB7kfyFaIHKmeyAXLRNdljl6ikR91K5riNuU5UzEpepnKd7oK9yxSu4znK5rlr5oCQwUeWKOeJUKh/NRoxkm+m5Wa6M5j8+LspORV91+TPnabBrLhd3xM3N5bg6eZXXvLgmsIplg+5m+9a4MZWrq5UPSgIT63JFR9whKpamhWb1Ul9CpN8/QJ4RbfCXKma0xg2p3ETk+6lcNkcc7NXsiqW5qV5k8p+sYjHpVPTz6/N+u14N/iTLfiqXdcShXo3mcmoNtZKy1hT6Swe4LJgnvPpORWUuH62+KPYY+8yw4dinWOXdQqhQhkLlBhAbl1VfFHuofCNe/s4LFjPM1TIhlxtAYJzxeWbFYoSTq/ywcB10kD1U7pXXCq6DDrKHyr3yWsF10EH2UuWBwDehrfINLiyn9o/GawXXQQfZQ+Veea3gOugge6jcK68VXAcdZA+VZ9hkVAgc4GS2UiNK3/G8vIB44DMNqbxuHlNS1tDPRcbb180RJ5yLoh6vKdbXi/zFAG41HPs8TUdc3TwmBXnAFnORcfbFc8RhXjEqyQVHDV4mLKLUtTFx7PNEHXF185gUyM1r0lwUujnihHNRvICID7wSuuovViLiAOLy/R1xZfOYGNjZnDSvkGKOON1cFCkTaFd8zHqZyhmbL/TjcoqOuM/mMTG6Z1M5iw2jckVHXN+robq8Lpq7eav+CkMhyH98XM7REUe2FwyjezYndU9rOuIQr7p1ef2BT8l8egb3xDUx9R4rU/nova7L3lE5eysfA3M29XORcfalHXGgV7xK+MSc79b8zOzQNFLshshi6u8lTcXygKxWKdh7ubxuHlNTlrCYi4yzL+uIg70C63JqsV7Z3aG5yOQ/WcVyro64unlMBuqATeYiY+w/OEY74nCvkCeJeXj4RJ4vUtJv5vL6pgHKgvY/OuIUlMe1bzr2WYi1/r/YjfoispKia9oH/TeB2HhxfY5m8YI9VD6Xt5nOUy9L4fvnarbO5QYQGGd8HtV6qNw9rxVcBx1kD5V75bWC66CD7KFyr7xWcB10kL1UeSDwTWirfIMLy6n9o/FawXXQQfZQuVdeK7gOOsgeKvfKawXXQQfZQ+UZJnTEIc93uyM+zG751u94Xl5APPCZhlSub4sqKCdRcCdU1RHX8QpU+VKh2KfeoQjw0DXAXxKg/6fpiLNoiyooJ1HQ0ZJ2xGFeyXJ5U7KMjqnFiWOf5+mIK15SndwRp3q3tx+tFg/QEdfxiuJlsnJq5W/m0BId7OYXh/Lf1LgIVN68p+Enqsk+8uatrr25fzZ1r+BS9rUdcT2vrHI5E9E8QyP2mXvCqP8pnaMj7vZTwV4us7ookrrzirGv6YhDvMJVTuWkIpDFB2prsVKc/6bGxUldnkH5pyqwO+Ok7mbxHHF9r7oqb+qsqf5iEyXoppFiJa6JqXGRqRy5AQ6x4yqf1iv0yTHjL1Uo5ojre9Wty6mtxT58DmZyf8FILY76n+MEHXGXZwXbnZEepCxg0nnF2Jd1xOFeGdblxSYmbdeLDJGsYjlnR9y85+UGnVesfdkccahX26u8mcsLHeCymBoXZS6n7lqj7DH2mWHm2Ge3GuHzFij9RF8zMv+VEBuvD1+g9VD5FrxMbAr1p5Ycu/m7tmOayw0gMM6ftCGth8rd81rBddBB9lC5V14ruA46yB4q98prBddBB9lLlQcCX4OXtj9UvtlFFghsiVB54PsRKg98P0Llge/H/wFuSOo3+Y5FxAAAAABJRU5ErkJggg==" alt="" width="247" height="176" />

那如何我要显示产品编码+产品类别(6801_1), 最后数据为这样格式,该怎么修改呢?

6801_1    6801    电子仪器    Ⅰ类
6802_1    6802    激光仪器    Ⅰ类
6803_1    6803    扫描仪器    Ⅰ类
6801_2    6801    电子仪器    Ⅱ类
6802_2    6802    激光仪器    Ⅱ类
6803_2    6803    扫描仪器    Ⅱ类
6801_3    6801    电子仪器    Ⅲ类
6802_3    6802    激光仪器    Ⅲ类
6803_3    6803    扫描仪器    Ⅲ类

--5、查询经营范围(6801_1)方法--
select (CAST(A.Code as varchar(20))+'_'+CAST(B.Mid as varchar(20))) CateLevel,
A.Code CateCode,A.Name CateName,B.Name LevelName
from GoodsCate A
cross join
GoodsLevel B

最后结果

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAS8AAADhCAIAAAAWKaT/AAAaUElEQVR4nO2dy2ocuxaG6506MaTeJYRM6kE2BDLsUaBnHgRDODkTH+ixhyEu2MOwaTwKG4JJwM4oM51BdatVuiwt3aq01OvDmO5qtfSrrL+WVJfl7olhmDro1hbAMMwRdiPD1AK7kWFqofuHLGvvOobJTPfPP/8IgrAbmfYg7Mb6WfuPyxCDsBvX3nUe6lfI1AbkxmE3Wn82g/6zpA8nzLF+d3d3d3d3O+f6+uMqu/WJ3ciE43HjbhTHn50YHD+wG7uuA95mdONup8t4fHwcdrtVdusTu5EJJyw2mlFxM4ybTZIbOzdxbnx+fh5/ivGnuPn6NAzsRoYMkBvVaHN/fy9f393dTS/+/Pmz242bzeC1ImA21XWu13g3fvv2bRzH+/v7m69Pu92Y6Mauc16PBT6aYDcyoWDdKB0ohLi9vZ2s+Pz8vNuNr1698loR8FjG2Lgbx9vb291uvL7+OP0EuVEaDH7hQquN3ciEArnx+vrjt2/f7u/v7+ZMI346RwK70TSV1Y3e10g3amVuvj4dg+Q47sbx4eHBvzvm9lN/awVcX5SwG5lQPG6Ur9XYuNuNz8/P0/Ls+vqjy42aqVxxL2Ns/P79++Pj4+Pj4ziKm69PN1+fVM2bzYAx5GzvGB7j2MiUI3im+ufPn9vbW3mmBHYj7KiU8lY3Pjw8zAL4OE7dELthtxvv7+8BQ2oB0GU2jo1MOSA3fvjwYRzHaXDLJdn0W67Ndrudd6Y6ecwa94BQA4dHzEz16EYhhBAPDw+bYdhshs1mcO4Lt+U6Xjcy5fG48Tyyd+N02ub5+fn6+uP4U0yzwQ8fPgDnVDVzWl+rW9TfMC43TkH78fFx/Hly424QwyCEGHab3W7cDE43nncKx0ZmDbBunGancq0oF2ZeN6qx0eXGzjj76jUk4MbJiuPP2Uz7+fn54eFhN45AbDzvFI6NzBp43CjPoKqz0+lU6ocTLjdqU03rFNQs4/o60o3SiuN4cuMwiGHz/fv3YbfxurE7nUT1mu3JHScn2I1MKB43vnr1arMZtN/qiwlXDZo5ra9dZWA8bhzFMG7kOeHHx8dv377d3d1NZ1ad+wK3brSW5NjIpNPOMxzTWdPpHoDp5+jGYSOGzf39/WbYAG7swIuKLjcCG9mNTChNuXEzDG/evNkMw/QzufF49f80045YN8qZquZYbR7LbmQSaceNJpP3zJ8FdusTu5EJp2U3rkv9CpnaIOxGhmkMqm5kmPaYufE///0f//AP/6z1o7uxqPX//fffovWXhrR+0uIlbfRCRe0RuzEA0vpJi5e00QsVdmMkpPWTFi9poxcq7MZISOsnLV7SRi9U6nLjYTv00/0sfT/sD8GVHrZ9vw3/WkwlRfSH1hDb31I7v1PUZPlbgFh6kXcArNqjld049f04DA77obN1Hd4jq7oxXT+qhnCpJqV2ftedv9eIG1fr0bpuxPW1Xjem6w9Xn82N2Xb+duiHfZI2PEu4cb0erepGV1f3p+lT1w/76WB1OlzJqVU/HL9pVqKXUY76h23fDXuzTJwb0/W7alCK7edb+r537oqFxctK5kP5oFcybR+GYYo6++3QT5ULa51BvbB2JGUArNqjKt2oFTgXU75g7i+z0tNL+dc4/S2MMnndiNdvr2GSqQk+bTl2xrYrFhYv1D3ca/tVr2T6C6gvsvTC8sW0AbBqj6p042E79PJINN9Ts8eY1L2g1OkscypqltlnHdB4/dZ21WpN055Hg9HNhcXPdv5+mBd2VqKFoMRemB1JHACr9qjCdeN+kOcWzONWd5q5ueqwljkWctcTeWBO12+rAetGs5sLizdizDD0/fYAV6KP3cRe5B4Aq/aownOq+6EbTnOjYXYcmvaiNm+yTFSMMtPLXn03LxM7TUrXb6tBmZeaM9XjzMjezYXFz5veD8dg4K5Ef5GhF5kHwKo9qul642kdfF4GH89Y7Ld91x0X33vLiQR1ajDsLWWEMr8/vt1nOIuTRb+tBqUKJSQeS5zGlLWby+/83rKP9UqcYzdHL/IOgFV7tL4bCUFaP2nxkjZ6ocJujIS0ftLiJW30QoXdGAlp/aTFS9rohQq7MRLS+kmLl7TRCxV2YySk9ZMWL2mjFyqQG4tnxTL+Symt3wyTF9WZFjeWOww8PT39+PWb7k8X+O8oq6LoX3Yx2uiFZGU3dl23uqmif0gPBdLiJW30QsKxkWMjYdrohYR4bBz//jJSjo2HwwFxf0YJMOKzHG468J9wqrfNmG+9hP4JKj+AxrrxsB0Cb4e1tu0c65/evui6rutevPk8bfnybtpy9frd39OWmzdXXXf1Qinz49fvH+P7193bG4+HEWUSY+P5dij9gUR5f9R+6Luu75UyuXYshnQ3djbgSswCmldh65oA41O9o82stk5bRrhR3giYwY2O2Pj5dde9/vT7x6+//3rTvf70+8f4/kX39mb8/WP8/Lq7+mv8/WN8/+Ll+y+/fv/49fdfL6/+GqcXkzDAaZgy6bFxP3TyIdb5bd4yw8Xs9mvtIaU13Wj1GCZYea0oHK4oEhuNO41Vt9dpRZEwU90XjI2f3nZHp52j2cl7v28mf356251C4nHL2clep2HKJMRGM6eMMjiOO07Zf/NdmWHHYgDc6H0Nf8vcDoRE60a8W7xuBA4ueM8vxsputMbGL++uOnXyqQbA8fPrl29vfv3+8u7qxWnKqr5e0o2unWN7qE0+MWV5iHx+HKfnRsCKcW6Em1Ph2DhRMDZ+eXf14s3b1y+7Tl0Tju9fvLx68fJqCoM1uNH1R50eSz0tE/fK1r7vjxtqdmNoGAGsZQ131mlqXODideNE6dgo14SndeN8lViDG8HYqDySu7esEmt2I+Y10kWwG812Q02CcSMQuoPaWoAaY+OPT281p1m8V/e60Zs6o6V1I/IjYNZqWt2pew5+puqVWgM1xsajW06nSY/nbF56omU9sfG4c9TUGefzOs5omXHHYig9U7V+ZL4FAleWmSo+jNdAlbHxl+V6482bq86yxbjeWENsFJbrjTIB53yLcb2xAjdaX7u2uDa6arMaUhoj1CdBsdEVnOuB78UpERvRULsXJ9qNLpNrBazlAZB/As3eFUbFiYbvU/38Wp+VZIiH2NhYPUHj2BWyvHHMFY5U1xWJjXOFoR+tBfHYuOoP6VuWSYuXtNELScOxsfhPbUfWINoYx230QsKxkWMjYdrohcTvxtJ0FSTUSPnNMBnxuHGxIwE5SOsnLV7SRi8k7MZ4SOsnLV7SRi8k7MZ4SOsnLV7SRi8kxN243tVzQVw/Rrzrkj1QDPjUdedA0euNQVJXJ8aN55u8MP90B922tY2gTBZYYZmyXaymPwcu8eZ1eW27+RY2LfLTbn6fQKobL+WJKvV/14X+q0iw7Xkb4ZksUMJyZrtYQ382gEOJagzNJGYx6wuzDPCVIrHxwp42FgL7bw6xbZ9JymSBEZbnzuz19GfAO8fDmATpWK9LtY14t3jd2PlANrQMKW4sFRvTMllghJV1Y3n9GcC4Ucxv5nSNXWB7nBuBOjU4Nh7R/jlsettqzQmZLDDCiruxsP4MBK0btUGMCTjmV4AmogPXxa8bhRDHoZU6YsDYEpnJAidsgdhYVH8GvOtG8wUc4uBwhywZahKMG0ND+orEuDHXwRtYd8VlskALK75uLKw/A/BMFQ50ajHra6CAtRKtGN4n+JkqILIewt2Yb1EDnpMMz2QRIKywG4vrzwBy3eh6a270FrC+BQJXlplq+mR4SYLduB9mnSlyTlXEZLIIEVbajaX1ZwBzhUMdr3BgVN+6LGqNjZoxQn0SFButAqqC78WJh7R+zFkc62+tmOuLmI2u5qz1B/XC1KY1WqcnibsRQgs2Xfb/b0H6JknvulEY4VH4wgu+vOq6IrFxLin0o7Vo2I3FIa2ftHhJG72QsBvjIa2ftHhJG72QsBvjIa2ftHhJG72Q+N3IMMxieNy42JGAHKT1kxYvaaMXEnZjPKT1kxYvaaMXEnZjPKT1kxYvaaMXEuJu5Kv/scDiMRfivFf2gWLqp0WvN7rE1EmMG427vvK0DbcRksnCJ6z2TBypOxYD0o36DRS2K/tAGRHoVdi6Ab24lCeq5A3Qh9S7Pd0DIjaThV9Y3Zk4Mu3YNPFC4J5CwsRG11ur28238b24tKeN0/NFOCtPzWThFVZ5Jo4FEnFA96kClgj1jGv0W78YEbi8brSG7lDPL0aCG5OfAHJVnprJwi+s7kwcizxalSs2AkNcjXiY+oEYG9yLi4qN04SvUAbHlEwWOGH1ZuLIsmNTxE9oxrAGE21kay9cn2obEwPXxa8bzxTNUhWZyQInrN5MHDj9GfC60eoHq0u1j1zGs1aibQw1CcaNmDhfCUlXOMplcIzLZIEWVmkmDsmKGRzhuKTNToUjvmnlte9aW3S9jevFpWTikGcHy8XGuEwWIcJqzMSRccemiRcicN2ofQSEQfMt0FCWmWr6ZHhJImLj4XxZrMy6UYiYTBYhwmrMxJFxx6aKL+NGa2zUjBHqk6DY6ArO9cD34sRDWv8yV/+RFhVub6f0Qm1Fa7ROTxJ3IwRn4oAAxAODVXOpsNnGGw/NevLHRlxfavNkw24sDmn9pMVL2uiFhN0YD2n9pMVL2uiFhN0YD2n9pMVL2uiFxO9GhmEWw+PGxY4E5CCtn7R4SRu9kLAb4yGtn7R4SRu9kLAb4yGtn7R4SRu9kBB3I1/9jwUjPsvlOPiCfunrjV5VVRHvRvOR2sS2tdojMlkcy4FX+c93qCXffbaK/lyku9F2E07wU4ul7sU53xk3uwvSrL8qW8a68bDtiz3fGJnJApNlYz/ozzrR0p8Pl3irxzDBymtF4TBDkdjocKOY274qK4pYN07P06Y+9ePclUmZLLB3hKc/tbSu/kQAN3pfw98ytwMh0boRbxK8G4GjDN78pYly437oh3250ZyWyQI5mgvGxkX0p5LRjYAV49wIN6fCsdEynrK0LUnJZIEczYdtn75wXFF/OhlnqoC1rOHOOk2Ni1eXvm5UVzklY2N0Jgv/aD5s+yyP1q+lPwspsRHvItiNZruh3ghyIxDDgxotR6gb5ZmGI/Vl4vCM5ixRcWIV/blYYKZqrcEsbBoYb4+ImapX84rEX+EoeBYkKpPF7LuA6HxjfQX9+Sg9U7V+ZL4F4lXemSo+nq9InW6My2Rx2uwezdoDyOT0ZyQ0Nrq2uDa6arMaUvoh1B5xsdGqpAb4Xpx4SOuPu/of7UaXybUC1vIAoX8Czef1RMUJ4m6E4EwcEEjx8IzOG8dcUUh1XZHY6OhI6EcL07Abi0NaP2nxkjZ6IWE3xkNaP2nxkjZ6IWE3xkNaP2nxkjZ6IfG7kWGYxfC4cbEjATlI6yctXtJGLyTsxnhI6yctXtJGLyTsxnhI6yctXtJGLyTE3chX/2PBiIfvy8F8JHwX9Be73uhSVRURblSvqifdWwbtyqhMFpgsGzVn4siozYtLvHldXttuvoVNi/y0y3svzoU8UZXxRkr3aI7KZIHJslFzJo6s2hLEW57HdYU11wuzDPCVIrHxUp42zvd/d527MimTBVZjrZk48mjz4p3jYUyCdKzXpdpGvEnwbux8IFssSpQbu77vM0yoXLsyLZOFowJMI4Gsqj8VjBvF/B5O15AFtse5EahTg2Pjtu+3x0lXmf80npbJAvU8ccWZOHI+Dw0QtG40F3XeOGN+BWgiOl7xuvFM4oQKjC2RmSwwWTZqzsSRS1u0eOEesnCIg8MdsmSoN4LcGBrbl6dGN0ZnslgsKq6oPxfwXxYOdGox62uggLUSrRjeHhEzVUDt6gS7UZ4dPJ8ezNS2QlQmi4VWi6vqzwdy3eh6a270FrC+BeJV3plq+qx4ASJi4+F8La2mTBaYLBs1Z+LIqy1FvAxi6jCFA6P61mVRa2zU/BBqj7jYaFVSA3wvTjyk9WPO4lh/a8VcX8RsdDVnrT+oFy40n9cTFSeIuxGCM3FAeNeNwgiPwhdV8OVV1xWJjQ5toR8tTMNuLA5p/aTFS9rohYTdGA9p/aTFS9rohYTdGA9p/aTFS9rohcTvRoZhFsPjxsWOBOQgrZ+0eEkbvZCwG+MhrZ+0eEkbvZCwG+MhrZ+0eEkbvZAQdyNf/Y8FFo+5/ua9sg8UUz9d5nqjS1VVRLnRuO0rS9twEyGZLCBdFDJxJO5XFEg36jdQ2K7sA2VEoFdh6wb04mKeqDLSTGRqG2oCmcni+F+X3blCKs/E4dWfj7jYaLUW4DfXW6vbzbfxvbiUp41Tn9xwtg01EZbJAvWkV8WZOBZIxAHdpwpYItQzrkFv/WJEvMK70RrDQ81fmmA3Znzux7UrUzNZoCRWnIljkUercsVGYGSrEQ9TPzynDevFhcRGe5qJHG17msBlsjhs+w6xJqw2EwdSfzp4N7piiDagtReuT7WNifHq0teNljQTmdqGmkBnshDqtxzUnIkDoz8LXjda/WB1qfaRy3jWSrSNod4IciMm4K9LzLrRPYyS2gaaQGaykADCas7EgdGfC++60fWpVgaOaUAs1Vp0vY3rxaVk4rCkmcjUNtQEIpPFOUUIIKziTBwo/fnIuG7UPgLCoPkWaCjvTDV9VrwAZK43ejNZYFKE1JyJI2OKk1TxZdxojY2aH0LtERcbXVF6dfhenHhI61/m6j/SosLt7ZReWPultV6VJ4m7EYIzcUAA4oExqrlU2GzjjYdmPfljo0050KlKPNmwG4tDWj9p8ZI2eiFhN8ZDWj9p8ZI2eiFhN8ZDWj9p8ZI2eiHxu5FhmMXwuHGxIwE5SOsnLV7SRi8k7MZ4SOsnLV7SRi8k7MZ4SOsnLV7SRi8kxN3IV/9jwYjPchUOvqC/2PVGr7waCHbj9MhPlkvq0K6MymRxLAdKypjtYhX9uUh3o35vhcNC5s0A1k+7vPfiWO6MI/BoVVpsPGxTBrW78qhMFucDhVtT1mwXK+jPh0u81WOYYOW1onB4oEhs9LlRzP1fgxVFohuVJ4cytK3Wm5DJAmmzDA8trao/FcCN3tfwt8ztQEi0bsR7I8KNwOEGfxQoRIIbk8ezq/K0TBa40ZzjoaU19SeT0Y2AFePcCDenwrHxSNos1dK2WnN0JgvMaM6V7WIt/VnIOFMFrGUNd9ZpalyY4nXjxPEYn7FtSVomC/xMtWiWqtL6U0mJjXgXwW402w21RJwbgWAe1Hp2It2YJVUEsO5KyGSBHc3pXVhXfyILzFStNVhnrabVnbrnpMxUveKXJ86NefK2gOckgzNZzL7rqDdvtovl9Wek9EzV+pH5FghThWaq6dPjckS58bDfbjMMmKDrdYhMFqfNYL64jNku1tCfjdDY6Nri2uiqzWpIaYNQVyTGRle4Xgu+Fyce0vrjrv5Hu9Flcq2AtTxA9J9AM/zqUXGCuBshOBMHBFI8PJHzxjFX8FFdVyQ2ugEqX92TDbuxOKT1kxYvaaMXEnZjPKT1kxYvaaMXEnZjPKT1kxYvaaMXEr8bGYZZDI8bFzsSkIO0ftLiJW30QsJujIe0ftLiJW30QsJujIe0ftLiJW30QkLcjXz1PxaMePi+HMxHwndBf/nrjS55NRDjRjOpRJa2Z0RlsjjffeYWVnMmDoz+XLjEm9flte3mW9i0yE+7vPfiXMoTVWZSiUxtK0RlstgP/n+6XHMmDoz+fACHEtUYrptpBG5Auzxc/F6cS3na2EwqkantM0mZLLTiLqrNxJFJnA/vHA9jEqRjvS7VNuK9EeHGzgey6RJEzFT1pBK52lYbSMhk4agA0UYoa+pPBuNGMb910zVSge1xbgTq1Lj42Cj0pBK52p5VH5/JQhy2PTyDrjsTh19/FoLWjeaizhtezK8ATUSHKV43uh6TTW1bbSE6k8Vh2+NEVZqJA60/Fe+60XwBhzg43CFLhloizo2hQX4xgt0ITrGS2j4Tm8kiKKpUmIljmag4Ac9U4UCnFrO+BgpYK9GK4V2RMlMFZK9FeGw0k0pkanveRngmC/RqsdJMHEusFjHij2jDFGm2oEoA45WbqaZPj8sRs240k0pkadvaBj6ThfZwsSPG1JuJA6c/G5grHOrohAOj+tZlUWts1GwQ6orE2GiVtCJ8L048pPVjzuJYf2vFXF/EbHQ1Z60/qBdeNMOvHhUniLsRgjNxQHjXjcIIj8IXTPDlVdcViY1ugMpX92TDbiwOaf2kxUva6IWE3RgPaf2kxUva6IWE3RgPaf2kxUva6IXE70aGYRbD48bFjgTkIK2ftHhJG72QsBvjIa2ftHhJG72QsBvjIa2ftHhJG72QEHcjX/2PBRaPuezmvbIPFFM/Xfh6o0teDcS4MVcyC2hXJmWygIRRyMSRQZsXpBv1GyhsV/aBMiLQq7B1A3pxKU9U5Utm4R4QsZksvMIqz8SRT1uCeCFwzxxhYqPrrdXt5tv4XlzI08baw0FVZuLAPCxVcyaOBRJxQPepApYI9YxrrFu/GBGmItxoDeahR4FCJMRGcdimpaly7crUTBaYR5NqzsSxyKNVuWIjMKDViIepH57ThvXiQmKjkMubfhiGIk8bp2SywGTZqDkTRy5t0eInNGNYQ4c2jrUXrk+1jYlh6uLXjQqJKRzB2BKZyUKo34KoNBNHLm3R4idcfrC6VPvIZTxrJdrGUEvEuRET+VchxY3Fnv2PzWShKltg4biu/kS860bXp1oZOKYBsVRr0fU2rheXlIljOK6AEp8YBM9JBmeywGTZqDkTR15tCeKFCFw3ah8BYdB8CzRUaKaaPj0uB5nrjd5MFrgsG/Vm4sirLUl8GTdaY6Nmg1BXJMZGV7heC74XJx7S+pe5+o+0qHB7O6UXAKbOGjxJ3I0QnIkDAhAPDE3NpcJmG288NOvJHxvdwL1b15MNu7E4pPWTFi9poxcSdmM8pPWTFi9poxcSdmM8pPWTFi9poxcSvxsZhlkGzZy6G4seCRiGAWA3MkwtsBsZphbYjQxTC+xGhqkFdiPD1AK7kWFq4f/wpXyAmm8BLgAAAABJRU5ErkJggg==" alt="" width="303" height="203" />

ps:

详细了解笛卡尔积网址:http://www.360doc.com/content/14/1229/21/7635_436727229.shtml